A Series of Fibs
By: John Vereen
For
my bonus exploration, I will explore the Fibonacci sequence using Excel. What
exactly is the Fibonacci sequence? Well, the Fibonacci sequence in a sequence
of numbers of the form an = an-1 + an-2. In other words, each successive number of the sequence is the sum of the
previous two numbers in the sequence. The Fibonacci sequence starts with the
numbers 0 and 1.
Using
Microsoft Excel, we have created four specific columns
Column 1 = Fibonacci sequence
Column 2 = ratio of consecutive terms = 1.618
Column 3 = ratio of every other term = 2.618
Column 4 = ratio of every third term = 4.236
We
notice a recurring theme with the ratio columns of the Fibonacci sequence. Whether
itŐs the ratio between consecutive numbers, every other number, or every third
number, there is always a limit to what the ratio will be. Each ratio column
starts out unstable and then levels out to a set ratio.
In
the image above, we explored the Lucas sequence. This sequence is similar to the
Fibonacci sequence, except we start with 1 and 3 instead of 0 and 1. The
columns are as follows:
Column 1 = Lucas sequence
Column 2 = ratio of consecutive terms = 1.618
Column 3 = ratio of every other term = 2.618
Column 4 = ratio of every third term = 4.236
It is fascinating that the columns for each ratio of the
consecutive terms, every other term, and every third term are the same for both
sequences despite the different initial values! Also, each initial ratio of
1.618 is equivalent to the golden ratio, which is a famous phenomenon of
mathematics.